/*
 Navicat Premium Data Transfer

 Source Server         : local
 Source Server Type    : MySQL
 Source Server Version : 50717
 Source Host           : 127.0.0.1
 Source Database       : ds_0

 Target Server Type    : MySQL
 Target Server Version : 50717
 File Encoding         : utf-8

 Date: 09/14/2017 14:58:28 PM
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `robot_contact_0`
-- ----------------------------
DROP TABLE IF EXISTS `robot_contact_0`;
CREATE TABLE `robot_contact_0` (
  `id` bigint(64) NOT NULL COMMENT '联系人id',
  `case_id` bigint(20) NOT NULL,
  `a_case_id` varchar(64) DEFAULT NULL COMMENT '甲方案件编号',
  `batch_no` bigint(20) DEFAULT NULL COMMENT '用户当天批量导入数据批次编号',
  `name` varchar(64) DEFAULT NULL COMMENT '姓名',
  `type` varchar(64) DEFAULT NULL COMMENT '类别',
  `detail` varchar(64) DEFAULT NULL COMMENT '详细',
  `remark` varchar(128) DEFAULT NULL COMMENT '备注',
  `mobile_status` varchar(24) DEFAULT NULL,
  `detail_src` varchar(16) DEFAULT NULL COMMENT '电话来源，如：通讯录',
  `source` varchar(4) DEFAULT 'web' COMMENT '数据来源: web  app  默认web',
  `is_delete` tinyint(2) DEFAULT '0' COMMENT '逻辑删除',
  `attribution` varchar(66) DEFAULT NULL COMMENT '电话归属地',
  `contact_status` varchar(20) DEFAULT NULL COMMENT '联系人状态',
  `port` int(4) DEFAULT NULL COMMENT '短信发送指定端口号',
  `promise_pay_time` datetime DEFAULT NULL COMMENT '承诺还款时间，短息解析的承诺的最近还款时间',
  `create_user_id` bigint(20) DEFAULT NULL COMMENT '创建人id',
  `update_user_id` bigint(20) DEFAULT NULL COMMENT '修改人id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '系统更新时间',
  `message_port` tinyint(2) NOT NULL DEFAULT '0' COMMENT '发送短信端口',
  `content` varchar(50) DEFAULT NULL COMMENT '评价内容',
  PRIMARY KEY (`id`),
  KEY `idx_a_case_id` (`a_case_id`) USING BTREE,
  KEY `idx_contact_detail` (`detail`) USING BTREE,
  KEY `idx_case_id` (`case_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='闪电猫案件联系人信息表0';

SET FOREIGN_KEY_CHECKS = 1;
/*
 Navicat Premium Data Transfer

 Source Server         : local
 Source Server Type    : MySQL
 Source Server Version : 50717
 Source Host           : 127.0.0.1
 Source Database       : ds_0

 Target Server Type    : MySQL
 Target Server Version : 50717
 File Encoding         : utf-8

 Date: 09/14/2017 14:58:40 PM
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `robot_contact_1`
-- ----------------------------
DROP TABLE IF EXISTS `robot_contact_1`;
CREATE TABLE `robot_contact_1` (
  `id` bigint(64) NOT NULL COMMENT '主键编号',
  `case_id` bigint(20) NOT NULL,
  `a_case_id` varchar(64) DEFAULT NULL COMMENT '甲方案件编号',
  `batch_no` bigint(20) DEFAULT NULL COMMENT '用户当天批量导入数据批次编号',
  `name` varchar(64) DEFAULT NULL COMMENT '姓名',
  `type` varchar(64) DEFAULT NULL COMMENT '类别',
  `detail` varchar(64) DEFAULT NULL COMMENT '详细',
  `remark` varchar(128) DEFAULT NULL COMMENT '备注',
  `mobile_status` varchar(24) DEFAULT NULL,
  `detail_src` varchar(16) DEFAULT NULL COMMENT '电话来源，如：通讯录',
  `source` varchar(4) DEFAULT 'web' COMMENT '数据来源: web  app  默认web',
  `is_delete` tinyint(2) DEFAULT '0' COMMENT '逻辑删除',
  `attribution` varchar(66) DEFAULT NULL COMMENT '电话归属地',
  `contact_status` varchar(20) DEFAULT NULL COMMENT '联系人状态',
  `port` int(4) DEFAULT NULL COMMENT '短信发送指定端口号',
  `promise_pay_time` datetime DEFAULT NULL COMMENT '承诺还款时间，短息解析的承诺的最近还款时间',
  `create_user_id` bigint(20) DEFAULT NULL COMMENT '创建人id',
  `update_user_id` bigint(20) DEFAULT NULL COMMENT '修改人id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '系统更新时间',
  `message_port` tinyint(2) NOT NULL DEFAULT '0' COMMENT '发送短信端口',
  `content` varchar(50) DEFAULT NULL COMMENT '评价内容',
  PRIMARY KEY (`id`),
  KEY `idx_a_case_id` (`a_case_id`) USING BTREE,
  KEY `idx_contact_detail` (`detail`) USING BTREE,
  KEY `idx_case_id` (`case_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='闪电猫案件联系人信息表1';

SET FOREIGN_KEY_CHECKS = 1;
/*
 Navicat Premium Data Transfer

 Source Server         : local
 Source Server Type    : MySQL
 Source Server Version : 50717
 Source Host           : 127.0.0.1
 Source Database       : ds_0

 Target Server Type    : MySQL
 Target Server Version : 50717
 File Encoding         : utf-8

 Date: 09/14/2017 14:58:45 PM
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `robot_contact_2`
-- ----------------------------
DROP TABLE IF EXISTS `robot_contact_2`;
CREATE TABLE `robot_contact_2` (
  `id` bigint(64) NOT NULL COMMENT '主键编号',
  `case_id` bigint(20) NOT NULL,
  `a_case_id` varchar(64) DEFAULT NULL COMMENT '甲方案件编号',
  `batch_no` bigint(20) DEFAULT NULL COMMENT '用户当天批量导入数据批次编号',
  `name` varchar(64) DEFAULT NULL COMMENT '姓名',
  `type` varchar(64) DEFAULT NULL COMMENT '类别',
  `detail` varchar(64) DEFAULT NULL COMMENT '详细',
  `remark` varchar(128) DEFAULT NULL COMMENT '备注',
  `mobile_status` varchar(24) DEFAULT NULL,
  `detail_src` varchar(16) DEFAULT NULL COMMENT '电话来源，如：通讯录',
  `source` varchar(4) DEFAULT 'web' COMMENT '数据来源: web  app  默认web',
  `is_delete` tinyint(2) DEFAULT '0' COMMENT '逻辑删除',
  `attribution` varchar(66) DEFAULT NULL COMMENT '电话归属地',
  `contact_status` varchar(20) DEFAULT NULL COMMENT '联系人状态',
  `port` int(4) DEFAULT NULL COMMENT '短信发送指定端口号',
  `promise_pay_time` datetime DEFAULT NULL COMMENT '承诺还款时间，短息解析的承诺的最近还款时间',
  `create_user_id` bigint(20) DEFAULT NULL COMMENT '创建人id',
  `update_user_id` bigint(20) DEFAULT NULL COMMENT '修改人id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '系统更新时间',
  `message_port` tinyint(2) NOT NULL DEFAULT '0' COMMENT '发送短信端口',
  `content` varchar(50) DEFAULT NULL COMMENT '评价内容',
  PRIMARY KEY (`id`),
  KEY `idx_a_case_id` (`a_case_id`) USING BTREE,
  KEY `idx_contact_detail` (`detail`) USING BTREE,
  KEY `idx_case_id` (`case_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='闪电猫案件联系人信息表2';

SET FOREIGN_KEY_CHECKS = 1;
/*
 Navicat Premium Data Transfer

 Source Server         : local
 Source Server Type    : MySQL
 Source Server Version : 50717
 Source Host           : 127.0.0.1
 Source Database       : ds_0

 Target Server Type    : MySQL
 Target Server Version : 50717
 File Encoding         : utf-8

 Date: 09/14/2017 14:58:51 PM
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `robot_contact_3`
-- ----------------------------
DROP TABLE IF EXISTS `robot_contact_3`;
CREATE TABLE `robot_contact_3` (
  `id` bigint(64) NOT NULL COMMENT '主键编号',
  `case_id` bigint(20) NOT NULL,
  `a_case_id` varchar(64) DEFAULT NULL COMMENT '甲方案件编号',
  `batch_no` bigint(20) DEFAULT NULL COMMENT '用户当天批量导入数据批次编号',
  `name` varchar(64) DEFAULT NULL COMMENT '姓名',
  `type` varchar(64) DEFAULT NULL COMMENT '类别',
  `detail` varchar(64) DEFAULT NULL COMMENT '详细',
  `remark` varchar(128) DEFAULT NULL COMMENT '备注',
  `mobile_status` varchar(24) DEFAULT NULL,
  `detail_src` varchar(16) DEFAULT NULL COMMENT '电话来源，如：通讯录',
  `source` varchar(4) DEFAULT 'web' COMMENT '数据来源: web  app  默认web',
  `is_delete` tinyint(2) DEFAULT '0' COMMENT '逻辑删除',
  `attribution` varchar(66) DEFAULT NULL COMMENT '电话归属地',
  `contact_status` varchar(20) DEFAULT NULL COMMENT '联系人状态',
  `port` int(4) DEFAULT NULL COMMENT '短信发送指定端口号',
  `promise_pay_time` datetime DEFAULT NULL COMMENT '承诺还款时间，短息解析的承诺的最近还款时间',
  `create_user_id` bigint(20) DEFAULT NULL COMMENT '创建人id',
  `update_user_id` bigint(20) DEFAULT NULL COMMENT '修改人id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '系统更新时间',
  `message_port` tinyint(2) NOT NULL DEFAULT '0' COMMENT '发送短信端口',
  `content` varchar(50) DEFAULT NULL COMMENT '评价内容',
  PRIMARY KEY (`id`),
  KEY `idx_a_case_id` (`a_case_id`) USING BTREE,
  KEY `idx_contact_detail` (`detail`) USING BTREE,
  KEY `idx_case_id` (`case_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='闪电猫案件联系人信息表3';

SET FOREIGN_KEY_CHECKS = 1;
/*
 Navicat Premium Data Transfer

 Source Server         : local
 Source Server Type    : MySQL
 Source Server Version : 50717
 Source Host           : 127.0.0.1
 Source Database       : ds_0

 Target Server Type    : MySQL
 Target Server Version : 50717
 File Encoding         : utf-8

 Date: 09/14/2017 14:58:56 PM
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `robot_contact_4`
-- ----------------------------
DROP TABLE IF EXISTS `robot_contact_4`;
CREATE TABLE `robot_contact_4` (
  `id` bigint(64) NOT NULL COMMENT '主键编号',
  `case_id` bigint(20) NOT NULL,
  `a_case_id` varchar(64) DEFAULT NULL COMMENT '甲方案件编号',
  `batch_no` bigint(20) DEFAULT NULL COMMENT '用户当天批量导入数据批次编号',
  `name` varchar(64) DEFAULT NULL COMMENT '姓名',
  `type` varchar(64) DEFAULT NULL COMMENT '类别',
  `detail` varchar(64) DEFAULT NULL COMMENT '详细',
  `remark` varchar(128) DEFAULT NULL COMMENT '备注',
  `mobile_status` varchar(24) DEFAULT NULL,
  `detail_src` varchar(16) DEFAULT NULL COMMENT '电话来源，如：通讯录',
  `source` varchar(4) DEFAULT 'web' COMMENT '数据来源: web  app  默认web',
  `is_delete` tinyint(2) DEFAULT '0' COMMENT '逻辑删除',
  `attribution` varchar(66) DEFAULT NULL COMMENT '电话归属地',
  `contact_status` varchar(20) DEFAULT NULL COMMENT '联系人状态',
  `port` int(4) DEFAULT NULL COMMENT '短信发送指定端口号',
  `promise_pay_time` datetime DEFAULT NULL COMMENT '承诺还款时间，短息解析的承诺的最近还款时间',
  `create_user_id` bigint(20) DEFAULT NULL COMMENT '创建人id',
  `update_user_id` bigint(20) DEFAULT NULL COMMENT '修改人id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '系统更新时间',
  `message_port` tinyint(2) NOT NULL DEFAULT '0' COMMENT '发送短信端口',
  `content` varchar(50) DEFAULT NULL COMMENT '评价内容',
  PRIMARY KEY (`id`),
  KEY `idx_a_case_id` (`a_case_id`) USING BTREE,
  KEY `idx_contact_detail` (`detail`) USING BTREE,
  KEY `idx_case_id` (`case_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='闪电猫案件联系人信息表4';

SET FOREIGN_KEY_CHECKS = 1;
/*
 Navicat Premium Data Transfer

 Source Server         : local
 Source Server Type    : MySQL
 Source Server Version : 50717
 Source Host           : 127.0.0.1
 Source Database       : ds_0

 Target Server Type    : MySQL
 Target Server Version : 50717
 File Encoding         : utf-8

 Date: 09/14/2017 14:59:07 PM
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `robot_contact_5`
-- ----------------------------
DROP TABLE IF EXISTS `robot_contact_5`;
CREATE TABLE `robot_contact_5` (
  `id` bigint(64) NOT NULL COMMENT '主键编号',
  `case_id` bigint(20) NOT NULL,
  `a_case_id` varchar(64) DEFAULT NULL COMMENT '甲方案件编号',
  `batch_no` bigint(20) DEFAULT NULL COMMENT '用户当天批量导入数据批次编号',
  `name` varchar(64) DEFAULT NULL COMMENT '姓名',
  `type` varchar(64) DEFAULT NULL COMMENT '类别',
  `detail` varchar(64) DEFAULT NULL COMMENT '详细',
  `remark` varchar(128) DEFAULT NULL COMMENT '备注',
  `mobile_status` varchar(24) DEFAULT NULL,
  `detail_src` varchar(16) DEFAULT NULL COMMENT '电话来源，如：通讯录',
  `source` varchar(4) DEFAULT 'web' COMMENT '数据来源: web  app  默认web',
  `is_delete` tinyint(2) DEFAULT '0' COMMENT '逻辑删除',
  `attribution` varchar(66) DEFAULT NULL COMMENT '电话归属地',
  `contact_status` varchar(20) DEFAULT NULL COMMENT '联系人状态',
  `port` int(4) DEFAULT NULL COMMENT '短信发送指定端口号',
  `promise_pay_time` datetime DEFAULT NULL COMMENT '承诺还款时间，短息解析的承诺的最近还款时间',
  `create_user_id` bigint(20) DEFAULT NULL COMMENT '创建人id',
  `update_user_id` bigint(20) DEFAULT NULL COMMENT '修改人id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '系统更新时间',
  `message_port` tinyint(2) NOT NULL DEFAULT '0' COMMENT '发送短信端口',
  `content` varchar(50) DEFAULT NULL COMMENT '评价内容',
  PRIMARY KEY (`id`),
  KEY `idx_a_case_id` (`a_case_id`) USING BTREE,
  KEY `idx_contact_detail` (`detail`) USING BTREE,
  KEY `idx_case_id` (`case_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='闪电猫案件联系人信息表5';

-- ----------------------------
--  Records of `robot_contact_5`
-- ----------------------------
BEGIN;
INSERT INTO `robot_contact_5` VALUES ('86196476572602367', '5153', '1123', '118', '林彦廷', 'benrendianhua', '15801794498', '本人', null, null, 'web', '0', null, 'willingPay', '26', null, '1', '1', '2017-06-26 20:34:01', '2017-09-14 14:56:41', '0', null), ('86196476572602368', '5165', '1123', '118', '林彦廷', 'benrendianhua', '15801794498', '本人', null, null, 'web', '0', null, 'willingPay', '26', null, '1', '1', '2017-06-26 20:34:01', '2017-09-13 13:26:13', '0', null);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
/*
 Navicat Premium Data Transfer

 Source Server         : local
 Source Server Type    : MySQL
 Source Server Version : 50717
 Source Host           : 127.0.0.1
 Source Database       : ds_0

 Target Server Type    : MySQL
 Target Server Version : 50717
 File Encoding         : utf-8

 Date: 09/14/2017 14:59:12 PM
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `robot_contact_6`
-- ----------------------------
DROP TABLE IF EXISTS `robot_contact_6`;
CREATE TABLE `robot_contact_6` (
  `id` bigint(64) NOT NULL COMMENT '主键编号',
  `case_id` bigint(20) NOT NULL,
  `a_case_id` varchar(64) DEFAULT NULL COMMENT '甲方案件编号',
  `batch_no` bigint(20) DEFAULT NULL COMMENT '用户当天批量导入数据批次编号',
  `name` varchar(64) DEFAULT NULL COMMENT '姓名',
  `type` varchar(64) DEFAULT NULL COMMENT '类别',
  `detail` varchar(64) DEFAULT NULL COMMENT '详细',
  `remark` varchar(128) DEFAULT NULL COMMENT '备注',
  `mobile_status` varchar(24) DEFAULT NULL,
  `detail_src` varchar(16) DEFAULT NULL COMMENT '电话来源，如：通讯录',
  `source` varchar(4) DEFAULT 'web' COMMENT '数据来源: web  app  默认web',
  `is_delete` tinyint(2) DEFAULT '0' COMMENT '逻辑删除',
  `attribution` varchar(66) DEFAULT NULL COMMENT '电话归属地',
  `contact_status` varchar(20) DEFAULT NULL COMMENT '联系人状态',
  `port` int(4) DEFAULT NULL COMMENT '短信发送指定端口号',
  `promise_pay_time` datetime DEFAULT NULL COMMENT '承诺还款时间，短息解析的承诺的最近还款时间',
  `create_user_id` bigint(20) DEFAULT NULL COMMENT '创建人id',
  `update_user_id` bigint(20) DEFAULT NULL COMMENT '修改人id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '系统更新时间',
  `message_port` tinyint(2) NOT NULL DEFAULT '0' COMMENT '发送短信端口',
  `content` varchar(50) DEFAULT NULL COMMENT '评价内容',
  PRIMARY KEY (`id`),
  KEY `idx_a_case_id` (`a_case_id`) USING BTREE,
  KEY `idx_contact_detail` (`detail`) USING BTREE,
  KEY `idx_case_id` (`case_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='闪电猫案件联系人信息表6';

-- ----------------------------
--  Records of `robot_contact_6`
-- ----------------------------
BEGIN;
INSERT INTO `robot_contact_6` VALUES ('86196477994471424', '5166', '1123', '118', '林彦廷', 'benrendianhua', '15801794498', '本人', null, null, 'web', '0', null, 'willingPay', '26', null, '1', '1', '2017-06-26 20:34:01', '2017-09-14 14:52:07', '0', null);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;

/*
 Navicat Premium Data Transfer

 Source Server         : new
 Source Server Type    : MySQL
 Source Server Version : 100125
 Source Host           : 106.75.67.95
 Source Database       : messagerobot

 Target Server Type    : MySQL
 Target Server Version : 100125
 File Encoding         : utf-8

 Date: 09/18/2017 22:15:45 PM
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `robot_case`
-- ----------------------------
DROP TABLE IF EXISTS `robot_case`;
CREATE TABLE `robot_case` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增流水 case_id',
  `batch_no` bigint(20) DEFAULT NULL COMMENT '用户当天批量导入数据批次编号',
  `a_case_id` varchar(64) DEFAULT NULL COMMENT '甲方案件编号',
  `name` varchar(64) DEFAULT NULL COMMENT '姓名',
  `age` int(11) DEFAULT NULL COMMENT '年龄',
  `gender` varchar(8) DEFAULT NULL COMMENT '性别',
  `id_no` varchar(96) DEFAULT NULL COMMENT '身份证号',
  `id_number` varchar(8) DEFAULT NULL COMMENT '身份证号码前6位',
  `address` varchar(128) DEFAULT NULL COMMENT '案件所在地',
  `household_register` varchar(128) DEFAULT NULL COMMENT '户籍',
  `company_address` varchar(128) DEFAULT NULL COMMENT '公司地址',
  `permanent_address` varchar(128) DEFAULT NULL COMMENT '常住地址',
  `mobile` varchar(16) DEFAULT NULL COMMENT '客户手机号',
  `loan_institutions` varchar(128) DEFAULT NULL COMMENT '贷款机构',
  `date_of_loan` date DEFAULT NULL COMMENT '放款日期',
  `date_of_borrow` date DEFAULT NULL COMMENT '借款日期',
  `loan_period` int(11) DEFAULT NULL COMMENT '借款期数',
  `amount` decimal(16,2) DEFAULT NULL COMMENT '借款金额',
  `loan_amount` decimal(16,2) DEFAULT NULL COMMENT '放款金额',
  `monthly_repay` decimal(16,2) DEFAULT NULL COMMENT '月还款额',
  `residual_principal` decimal(16,2) DEFAULT NULL COMMENT '剩余本金',
  `total_penalty` decimal(16,2) DEFAULT NULL COMMENT '罚滞总额',
  `last_repay_date` date DEFAULT NULL COMMENT '最近一次还款时间',
  `last_repay_amount` decimal(16,2) DEFAULT NULL COMMENT '最近一次还款金额',
  `person_company` varchar(64) DEFAULT NULL COMMENT '贷款客户所属公司',
  `start_time` datetime DEFAULT NULL COMMENT '起委时间',
  `end_time` datetime DEFAULT NULL COMMENT '结委时间',
  `overdue_status` int(8) DEFAULT NULL COMMENT '逾期状态',
  `overdue_time` int(5) DEFAULT '1' COMMENT '逾期次数',
  `overdue_dates` bigint(20) DEFAULT NULL COMMENT '逾期天数',
  `overdue_amount` decimal(16,4) DEFAULT NULL COMMENT '逾期总额',
  `loan_type` varchar(64) DEFAULT NULL COMMENT '贷款类型',
  `delegate_amount` decimal(16,2) DEFAULT NULL COMMENT '委托金额',
  `collect_method` varchar(64) DEFAULT NULL COMMENT '催收方式',
  `repayed_periods` bigint(4) DEFAULT NULL COMMENT '已还期数',
  `statement_date` bigint(4) DEFAULT NULL COMMENT '账单日',
  `loan_product_name` varchar(64) DEFAULT NULL COMMENT '借款产品名称',
  `bound_bank_card` varchar(64) DEFAULT NULL COMMENT '客户绑定划扣银行卡号',
  `commission_rate_a` decimal(16,4) DEFAULT NULL COMMENT '佣金费率（甲方）',
  `remark` varchar(256) DEFAULT NULL COMMENT '案件导入备注',
  `init_oper_id` bigint(20) DEFAULT NULL COMMENT '初始坐席号',
  `src_org_id` bigint(20) DEFAULT NULL COMMENT '案件所属机构id',
  `create_user_id` bigint(20) DEFAULT NULL COMMENT '创建人id',
  `update_user_id` bigint(20) DEFAULT NULL COMMENT '修改人id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '系统更新时间',
  `case_status` varchar(16) DEFAULT NULL COMMENT '案件状态',
  `plan_status` tinyint(1) unsigned DEFAULT NULL COMMENT '催收方案是否生效',
  `plan_start_time` datetime DEFAULT NULL COMMENT '方案开始时间',
  `plan_discount` int(3) DEFAULT NULL COMMENT '催收方案减免百分比',
  `plan_days` int(11) DEFAULT NULL COMMENT '方案设定时间',
  `plan_type` varchar(5) DEFAULT NULL COMMENT '方案类型',
  PRIMARY KEY (`id`),
  UNIQUE KEY `batch_no` (`batch_no`,`a_case_id`) USING BTREE,
  KEY `idx_a_case_id` (`a_case_id`) USING BTREE,
  KEY `idx_id_no` (`id_no`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=33265 DEFAULT CHARSET=utf8 COMMENT='闪电猫案件表';

SET FOREIGN_KEY_CHECKS = 1;
/*
 Navicat Premium Data Transfer

 Source Server         : new
 Source Server Type    : MySQL
 Source Server Version : 100125
 Source Host           : 106.75.67.95
 Source Database       : messagerobot

 Target Server Type    : MySQL
 Target Server Version : 100125
 File Encoding         : utf-8

 Date: 09/18/2017 22:16:03 PM
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `robot_dictionary`
-- ----------------------------
DROP TABLE IF EXISTS `robot_dictionary`;
CREATE TABLE `robot_dictionary` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增流水id',
  `model_type` varchar(64) DEFAULT NULL COMMENT '模块类别',
  `model_code` varchar(64) DEFAULT NULL COMMENT '代码',
  `model_name` varchar(216) DEFAULT NULL,
  `status` varchar(4) DEFAULT '1' COMMENT '1有效 0无效',
  `level` tinyint(4) DEFAULT NULL COMMENT '等级',
  `remark` varchar(64) DEFAULT NULL COMMENT '备注信息',
  `parent_model_code` varchar(64) DEFAULT '0' COMMENT '父类代码',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '系统更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_model_code` (`model_code`) USING BTREE,
  KEY `model_type` (`model_type`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=utf8 COMMENT='字典表';

SET FOREIGN_KEY_CHECKS = 1;
